Introduction

• ESG
• Fuel Regulation Standards
• Renewable Natural Gas (RNG)

Questions

• What is the future outlook on RNG?
• What states are leading the charge?

Required Packages

• tidyverse
  • readxl
  • dplyr
  • magrittr
  • ggplot2
• janitor
• data.table
• formattable
• plotly

Source Data

LFG Energy Project Data Files (March 2022)

#Read in data
landfillgas_raw = read_excel("Data/lmopdata.xlsx", sheet="LMOP Database")

Source: https://www.epa.gov/lmop/lmop-landfill-and-project-database

AgSTAR Livestock Anaerobic Digester Database

anaerobicdigesterfas_raw = read_excel("Data/agstar-livestock-ad-database.xlsx", sheet="Operational and Construction")

AgSTAR publishes updated data on this website periodically (generally, two times per year) to enhance public access to information and support the development of biogas recovery projects

Source: https://www.epa.gov/agstar/livestock-anaerobic-digester-database

RNG Facility Data

rng_facility_raw = read_csv("Data/RNG_Facilities.csv", show_col_types = FALSE)

Data Summary

LMOP Landfill and Landfill Gas Energy Project Database

names(landfillgas_raw)

##  [1] "GHGRP ID"                                               
##  [2] "Landfill ID"                                            
##  [3] "Landfill Name"                                          
##  [4] "State"                                                  
##  [5] "Physical Address"                                       
##  [6] "City"                                                   
##  [7] "County"                                                 
##  [8] "Zip Code"                                               
##  [9] "Latitude"                                               
## [10] "Longitude"                                              
## [11] "Ownership Type"                                         
## [12] "Landfill Owner Organization(s)"                         
## [13] "Year Landfill Opened"                                   
## [14] "Landfill Closure Year"                                  
## [15] "Current Landfill Status"                                
## [16] "Waste in Place (tons)"                                  
## [17] "Waste in Place Year"                                    
## [18] "LFG Collection System In Place?"                        
## [19] "LFG Collected (mmscfd)"                                 
## [20] "LFG Flared (mmscfd)"                                    
## [21] "Project ID"                                             
## [22] "Current Project Status"                                 
## [23] "Project Name"                                           
## [24] "Project Start Date"                                     
## [25] "Project Shutdown Date"                                  
## [26] "Project Type Category"                                  
## [27] "LFG Energy Project Type"                                
## [28] "RNG Delivery Method"                                    
## [29] "Actual MW Generation"                                   
## [30] "Rated MW Capacity"                                      
## [31] "LFG Flow to Project (mmscfd)"                           
## [32] "Current Year Emission Reductions (MMTCO2e/yr) - Direct" 
## [33] "Current Year Emission Reductions (MMTCO2e/yr) - Avoided"

AgSTAR Anaerobic Digester Database

names(anaerobicdigesterfas_raw)

##  [1] "Project Name"                                  
##  [2] "Project Type"                                  
##  [3] "City"                                          
##  [4] "County"                                        
##  [5] "State"                                         
##  [6] "Digester Type"                                 
##  [7] "Status"                                        
##  [8] "Year Operational"                              
##  [9] "Animal/Farm Type(s)"                           
## [10] "Cattle"                                        
## [11] "Dairy"                                         
## [12] "Poultry"                                       
## [13] "Swine"                                         
## [14] "Co-Digestion"                                  
## [15] "Biogas Generation Estimate (cu_ft/day)"        
## [16] "Electricity Generated (kWh/yr)"                
## [17] "Biogas End Use(s)"                             
## [18] "System Designer(s)_Developer(s) and Affiliates"
## [19] "Receiving Utility"                             
## [20] "Total Emission Reductions (MTCO2e/yr)"         
## [21] "Awarded USDA Funding?"

names(rng_facility_raw)

##  [1] "Facility Name"              "Category"                  
##  [3] "Type"                       "City"                      
##  [5] "State"                      "Start date"                
##  [7] "Gas Flow to project (scfm)" "Source"                    
##  [9] "Date updated"               "Latitude"                  
## [11] "Longitude"                  "x"                         
## [13] "y"

Data Cleaning

LMOP Landfill and Landfill Gas Energy Project Database

landfillgas_clean = clean_names(landfillgas_raw)
names(landfillgas_clean)

##  [1] "ghgrp_id"                                           
##  [2] "landfill_id"                                        
##  [3] "landfill_name"                                      
##  [4] "state"                                              
##  [5] "physical_address"                                   
##  [6] "city"                                               
##  [7] "county"                                             
##  [8] "zip_code"                                           
##  [9] "latitude"                                           
## [10] "longitude"                                          
## [11] "ownership_type"                                     
## [12] "landfill_owner_organization_s"                      
## [13] "year_landfill_opened"                               
## [14] "landfill_closure_year"                              
## [15] "current_landfill_status"                            
## [16] "waste_in_place_tons"                                
## [17] "waste_in_place_year"                                
## [18] "lfg_collection_system_in_place"                     
## [19] "lfg_collected_mmscfd"                               
## [20] "lfg_flared_mmscfd"                                  
## [21] "project_id"                                         
## [22] "current_project_status"                             
## [23] "project_name"                                       
## [24] "project_start_date"                                 
## [25] "project_shutdown_date"                              
## [26] "project_type_category"                              
## [27] "lfg_energy_project_type"                            
## [28] "rng_delivery_method"                                
## [29] "actual_mw_generation"                               
## [30] "rated_mw_capacity"                                  
## [31] "lfg_flow_to_project_mmscfd"                         
## [32] "current_year_emission_reductions_mmtco2e_yr_direct" 
## [33] "current_year_emission_reductions_mmtco2e_yr_avoided"

AgSTAR Anaerobic Digester Database

anaerobicdigesterfas_clean = clean_names(anaerobicdigesterfas_raw)
names(anaerobicdigesterfas_clean)

##  [1] "project_name"                                
##  [2] "project_type"                                
##  [3] "city"                                        
##  [4] "county"                                      
##  [5] "state"                                       
##  [6] "digester_type"                               
##  [7] "status"                                      
##  [8] "year_operational"                            
##  [9] "animal_farm_type_s"                          
## [10] "cattle"                                      
## [11] "dairy"                                       
## [12] "poultry"                                     
## [13] "swine"                                       
## [14] "co_digestion"                                
## [15] "biogas_generation_estimate_cu_ft_day"        
## [16] "electricity_generated_k_wh_yr"               
## [17] "biogas_end_use_s"                            
## [18] "system_designer_s_developer_s_and_affiliates"
## [19] "receiving_utility"                           
## [20] "total_emission_reductions_mtco2e_yr"         
## [21] "awarded_usda_funding"

RNG Facility Data

rng_facility_clean = clean_names(rng_facility_raw)
names(rng_facility_clean)

##  [1] "facility_name"            "category"                
##  [3] "type"                     "city"                    
##  [5] "state"                    "start_date"              
##  [7] "gas_flow_to_project_scfm" "source"                  
##  [9] "date_updated"             "latitude"                
## [11] "longitude"                "x"                       
## [13] "y"

EDA

LMOP Landfill and Landfill Gas Energy Project Database

AgSTAR Anaerobic Digester Database

Project Breakdown

RNG Opearational Project Count by Year

RNG Operational Project Count by State

Landfill RNG Project Map

Ag Gas Project Map

RNG Facility Locations

Landfill RNG Project Forecast

Ag RNG Production Forecast

Bio Gas Generation Estimate/day (cubic ft)

Electricity Generation Estimate/year (KWH)

Carbon Zero

Ag Emissions Reductions

Landfill Gas Emissions Reductions

Landfill Gas Emissions Avoidance